{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "likely-radio",
   "metadata": {},
   "source": [
    "# NonFungible Python API Tutorial "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d22e8023",
   "metadata": {},
   "source": [
    "This tutorial aims to be a quick guide to get you started using the NonFungible API integrated into messari's python library."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "593e4795",
   "metadata": {},
   "outputs": [],
   "source": [
    "from messari.nfts import NonFungible\n",
    "nf = NonFungible()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "cc655cd8",
   "metadata": {},
   "outputs": [],
   "source": [
    "collections = ['cryptopunks', 'doodles']\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "813f1412",
   "metadata": {},
   "source": [
    "## API Structure\n",
    "The NonFungible Python client contains a number of functions that wrap some of NonFungible's API endpoints. These include:\n",
    "\n",
    "Functions\n",
    "\n",
    "* get_collection_history\n",
    "* get_collection_stats\n",
    "* get_collection_summary\n",
    "\n",
    "Below are a few examples to showcase the functionality and types of data each function generates."
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ecd6b9b7",
   "metadata": {},
   "source": [
    "## Functions"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a40e89fa",
   "metadata": {},
   "source": [
    "### get_collection_history"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "3b1e3b3d",
   "metadata": {},
   "source": [
    "get collection history, "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "de221c03",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"10\" halign=\"left\">cryptopunks</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"10\" halign=\"left\">doodles</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>blockchain</th>\n",
       "      <th>transactionHash</th>\n",
       "      <th>blockNumber</th>\n",
       "      <th>blockTimestamp</th>\n",
       "      <th>assetId</th>\n",
       "      <th>project</th>\n",
       "      <th>nftAddress</th>\n",
       "      <th>nftTicker</th>\n",
       "      <th>marketAddress</th>\n",
       "      <th>usdPrice</th>\n",
       "      <th>...</th>\n",
       "      <th>totalPrice</th>\n",
       "      <th>totalDecimalPrice</th>\n",
       "      <th>feeUSDPrice</th>\n",
       "      <th>feeTotalPrice</th>\n",
       "      <th>feeTotalDecimalPrice</th>\n",
       "      <th>feeCollectors</th>\n",
       "      <th>saleType</th>\n",
       "      <th>buyer</th>\n",
       "      <th>seller</th>\n",
       "      <th>meta</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0xaa40b85f4a1a16fe3f6f424ada1a99053335420b167b...</td>\n",
       "      <td>13912264</td>\n",
       "      <td>2021-12-31T09:11:16.000Z</td>\n",
       "      <td>5902</td>\n",
       "      <td>cryptopunks</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>Ͼ</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>1204673.400</td>\n",
       "      <td>...</td>\n",
       "      <td>200000000000000000000</td>\n",
       "      <td>200</td>\n",
       "      <td>57190.50000</td>\n",
       "      <td>15000000000000000000</td>\n",
       "      <td>15.000</td>\n",
       "      <td>[0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0xb3b1d2405f16afc27a83fb9a43e1da5102a363d4</td>\n",
       "      <td>0xeef9a8b628e22ade70b509c45f6f1db1d43c0dd4</td>\n",
       "      <td>{'name': 'Doodle #7751', 'artist': ['Burnt Toa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0xbfe47e67ab24622b809b80fa357a2e72a8e345543b6b...</td>\n",
       "      <td>13901896</td>\n",
       "      <td>2021-12-29T18:32:33.000Z</td>\n",
       "      <td>6275</td>\n",
       "      <td>cryptopunks</td>\n",
       "      <td>0xb7f7f6c52f2e2fdb1963eab30438024864c313f6</td>\n",
       "      <td>WPUNKS</td>\n",
       "      <td>0x4748495153fb86637e4fdd8e50e3c1f611f15930</td>\n",
       "      <td>1133475.000</td>\n",
       "      <td>...</td>\n",
       "      <td>150000000000000000000</td>\n",
       "      <td>150</td>\n",
       "      <td>42918.41250</td>\n",
       "      <td>11250000000000000000</td>\n",
       "      <td>11.250</td>\n",
       "      <td>[0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0x6ec30fd91a504aad948839b985c7263888b2ad68</td>\n",
       "      <td>0x0d41f957181e584db82d2e316837b2de1738c477</td>\n",
       "      <td>{'name': 'Doodle #3954', 'artist': ['Burnt Toa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0x3f2066f45f5a48e95a9a87db3f1db1789553cbece2dd...</td>\n",
       "      <td>13903771</td>\n",
       "      <td>2021-12-30T01:29:09.000Z</td>\n",
       "      <td>7622</td>\n",
       "      <td>cryptopunks</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>Ͼ</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>913227.318</td>\n",
       "      <td>...</td>\n",
       "      <td>120000000000000000000</td>\n",
       "      <td>120</td>\n",
       "      <td>34460.46000</td>\n",
       "      <td>9000000000000000000</td>\n",
       "      <td>9.000</td>\n",
       "      <td>[0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0x4b4c13434aac5e99645a4d9e59fe497b3318f50f</td>\n",
       "      <td>0xd7510a925475cb8377bc8d2a7f1c792022b68df8</td>\n",
       "      <td>{'name': 'Doodle #6343', 'artist': ['Burnt Toa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0xee3a243e833cdde3456a3b5bd5b9f95add2438edf737...</td>\n",
       "      <td>13923097</td>\n",
       "      <td>2022-01-02T01:35:03.000Z</td>\n",
       "      <td>4770</td>\n",
       "      <td>cryptopunks</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>Ͼ</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>822235.500</td>\n",
       "      <td>...</td>\n",
       "      <td>119000000000000000000</td>\n",
       "      <td>119</td>\n",
       "      <td>33815.30775</td>\n",
       "      <td>8925000000000000000</td>\n",
       "      <td>8.925</td>\n",
       "      <td>[0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0x904778b44bd12a1f7c3f1b95ff3381a952296cd1</td>\n",
       "      <td>0xde2b87d1539904f4b37e98c0d5ce383e890006ef</td>\n",
       "      <td>{'name': 'Doodle #1085', 'artist': ['Burnt Toa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0xd22f3794e7791e3a53eaefab4cd4a37557fdeab178b2...</td>\n",
       "      <td>13912355</td>\n",
       "      <td>2021-12-31T09:31:42.000Z</td>\n",
       "      <td>642</td>\n",
       "      <td>cryptopunks</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>Ͼ</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>638379.840</td>\n",
       "      <td>...</td>\n",
       "      <td>100000000000000000000</td>\n",
       "      <td>100</td>\n",
       "      <td>28554.60000</td>\n",
       "      <td>7500000000000000000</td>\n",
       "      <td>7.500</td>\n",
       "      <td>[0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0x30ae2012d175c6e7945a4350c57fe737d085d470</td>\n",
       "      <td>0xbde3fe2c971018a0dfde5030b611e4aeb2ce3933</td>\n",
       "      <td>{'name': 'Doodle #7802', 'artist': ['Burnt Toa...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  cryptopunks                                                                 \\\n",
       "   blockchain                                    transactionHash blockNumber   \n",
       "0    ethereum  0xaa40b85f4a1a16fe3f6f424ada1a99053335420b167b...    13912264   \n",
       "1    ethereum  0xbfe47e67ab24622b809b80fa357a2e72a8e345543b6b...    13901896   \n",
       "2    ethereum  0x3f2066f45f5a48e95a9a87db3f1db1789553cbece2dd...    13903771   \n",
       "3    ethereum  0xee3a243e833cdde3456a3b5bd5b9f95add2438edf737...    13923097   \n",
       "4    ethereum  0xd22f3794e7791e3a53eaefab4cd4a37557fdeab178b2...    13912355   \n",
       "\n",
       "                                                  \\\n",
       "             blockTimestamp assetId      project   \n",
       "0  2021-12-31T09:11:16.000Z    5902  cryptopunks   \n",
       "1  2021-12-29T18:32:33.000Z    6275  cryptopunks   \n",
       "2  2021-12-30T01:29:09.000Z    7622  cryptopunks   \n",
       "3  2022-01-02T01:35:03.000Z    4770  cryptopunks   \n",
       "4  2021-12-31T09:31:42.000Z     642  cryptopunks   \n",
       "\n",
       "                                                         \\\n",
       "                                   nftAddress nftTicker   \n",
       "0  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb         Ͼ   \n",
       "1  0xb7f7f6c52f2e2fdb1963eab30438024864c313f6    WPUNKS   \n",
       "2  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb         Ͼ   \n",
       "3  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb         Ͼ   \n",
       "4  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb         Ͼ   \n",
       "\n",
       "                                                            ...  \\\n",
       "                                marketAddress     usdPrice  ...   \n",
       "0  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb  1204673.400  ...   \n",
       "1  0x4748495153fb86637e4fdd8e50e3c1f611f15930  1133475.000  ...   \n",
       "2  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb   913227.318  ...   \n",
       "3  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb   822235.500  ...   \n",
       "4  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb   638379.840  ...   \n",
       "\n",
       "                 doodles                                                       \\\n",
       "              totalPrice totalDecimalPrice  feeUSDPrice         feeTotalPrice   \n",
       "0  200000000000000000000               200  57190.50000  15000000000000000000   \n",
       "1  150000000000000000000               150  42918.41250  11250000000000000000   \n",
       "2  120000000000000000000               120  34460.46000   9000000000000000000   \n",
       "3  119000000000000000000               119  33815.30775   8925000000000000000   \n",
       "4  100000000000000000000               100  28554.60000   7500000000000000000   \n",
       "\n",
       "                                                                      \\\n",
       "  feeTotalDecimalPrice                                 feeCollectors   \n",
       "0               15.000  [0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]   \n",
       "1               11.250  [0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]   \n",
       "2                9.000  [0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]   \n",
       "3                8.925  [0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]   \n",
       "4                7.500  [0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]   \n",
       "\n",
       "                                                          \\\n",
       "    saleType                                       buyer   \n",
       "0  secondary  0xb3b1d2405f16afc27a83fb9a43e1da5102a363d4   \n",
       "1  secondary  0x6ec30fd91a504aad948839b985c7263888b2ad68   \n",
       "2  secondary  0x4b4c13434aac5e99645a4d9e59fe497b3318f50f   \n",
       "3  secondary  0x904778b44bd12a1f7c3f1b95ff3381a952296cd1   \n",
       "4  secondary  0x30ae2012d175c6e7945a4350c57fe737d085d470   \n",
       "\n",
       "                                               \\\n",
       "                                       seller   \n",
       "0  0xeef9a8b628e22ade70b509c45f6f1db1d43c0dd4   \n",
       "1  0x0d41f957181e584db82d2e316837b2de1738c477   \n",
       "2  0xd7510a925475cb8377bc8d2a7f1c792022b68df8   \n",
       "3  0xde2b87d1539904f4b37e98c0d5ce383e890006ef   \n",
       "4  0xbde3fe2c971018a0dfde5030b611e4aeb2ce3933   \n",
       "\n",
       "                                                      \n",
       "                                                meta  \n",
       "0  {'name': 'Doodle #7751', 'artist': ['Burnt Toa...  \n",
       "1  {'name': 'Doodle #3954', 'artist': ['Burnt Toa...  \n",
       "2  {'name': 'Doodle #6343', 'artist': ['Burnt Toa...  \n",
       "3  {'name': 'Doodle #1085', 'artist': ['Burnt Toa...  \n",
       "4  {'name': 'Doodle #7802', 'artist': ['Burnt Toa...  \n",
       "\n",
       "[5 rows x 44 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection_history_df = nf.get_collection_history(collections_in=collections, length=5)\n",
    "collection_history_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d49761c3",
   "metadata": {},
   "source": [
    "can do '' to get all collections"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "acbf589e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"21\" halign=\"left\"></th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>blockchain</th>\n",
       "      <th>transactionHash</th>\n",
       "      <th>blockNumber</th>\n",
       "      <th>blockTimestamp</th>\n",
       "      <th>assetId</th>\n",
       "      <th>project</th>\n",
       "      <th>nftAddress</th>\n",
       "      <th>nftTicker</th>\n",
       "      <th>marketAddress</th>\n",
       "      <th>usdPrice</th>\n",
       "      <th>...</th>\n",
       "      <th>totalPrice</th>\n",
       "      <th>totalDecimalPrice</th>\n",
       "      <th>feeUSDPrice</th>\n",
       "      <th>feeTotalPrice</th>\n",
       "      <th>feeTotalDecimalPrice</th>\n",
       "      <th>feeCollectors</th>\n",
       "      <th>saleType</th>\n",
       "      <th>buyer</th>\n",
       "      <th>seller</th>\n",
       "      <th>meta</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0x21dcce949d7137778294d3b40797b3f0c81928bd8661...</td>\n",
       "      <td>13928090</td>\n",
       "      <td>2022-01-02T20:05:08.000Z</td>\n",
       "      <td>11</td>\n",
       "      <td>superrare</td>\n",
       "      <td>0x41a322b28d0ff354040e2cbc676f0320d8c8850d</td>\n",
       "      <td>SUPR</td>\n",
       "      <td>0x41a322b28d0ff354040e2cbc676f0320d8c8850d</td>\n",
       "      <td>6.196021e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>1630000000000000000000</td>\n",
       "      <td>1630.0000</td>\n",
       "      <td>805482.756000</td>\n",
       "      <td>211900000000000000000</td>\n",
       "      <td>211.9000</td>\n",
       "      <td>[0x39cc9c86e67baf2129b80fe3414c397492ea8026, 0...</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0x63fed38f5d6f6fd6a899451c72322c44b9c5acb0</td>\n",
       "      <td>0xb67994792c214039c8328bb3e0835b6a8ea7e373</td>\n",
       "      <td>{'artist': ['N/A'], 'name': 'All Time High in ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0x851d5ec47f2d766278193961c3fd582011af1fda286f...</td>\n",
       "      <td>13896377</td>\n",
       "      <td>2021-12-28T22:17:44.000Z</td>\n",
       "      <td>3562</td>\n",
       "      <td>boredapeclub</td>\n",
       "      <td>0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d</td>\n",
       "      <td>BAYC</td>\n",
       "      <td>0x24550d7fbe64bfdbce7704251d3fe40b8a136c91</td>\n",
       "      <td>1.636232e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>430000000000000000000</td>\n",
       "      <td>430.0000</td>\n",
       "      <td>81811.585000</td>\n",
       "      <td>21500000000000000000</td>\n",
       "      <td>21.5000</td>\n",
       "      <td>[0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0x020ca66c30bec2c4fe3861a94e4db4a498a35872</td>\n",
       "      <td>0xfbe5c1ab13e206688775f117a9a90153d7fdcfd2</td>\n",
       "      <td>{'name': 'Bored Ape #3562', 'eyes': 'Zombie', ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0xaa40b85f4a1a16fe3f6f424ada1a99053335420b167b...</td>\n",
       "      <td>13912264</td>\n",
       "      <td>2021-12-31T09:11:16.000Z</td>\n",
       "      <td>5902</td>\n",
       "      <td>cryptopunks</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>Ͼ</td>\n",
       "      <td>0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb</td>\n",
       "      <td>1.204673e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>315000000000000000000</td>\n",
       "      <td>315.0000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0x801b68cc9f4fb094a28b30ca25664051e50ad3a9</td>\n",
       "      <td>0x1e3685ee600983bac782b182f245efd3bbb26455</td>\n",
       "      <td>{'tags': ['Hoodie', 'Small Shades', 'Shadow Be...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0xbfe47e67ab24622b809b80fa357a2e72a8e345543b6b...</td>\n",
       "      <td>13901896</td>\n",
       "      <td>2021-12-29T18:32:33.000Z</td>\n",
       "      <td>6275</td>\n",
       "      <td>cryptopunks</td>\n",
       "      <td>0xb7f7f6c52f2e2fdb1963eab30438024864c313f6</td>\n",
       "      <td>WPUNKS</td>\n",
       "      <td>0x4748495153fb86637e4fdd8e50e3c1f611f15930</td>\n",
       "      <td>1.133475e+06</td>\n",
       "      <td>...</td>\n",
       "      <td>300000000000000000000</td>\n",
       "      <td>300.0000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>primary</td>\n",
       "      <td>0xd66fe503aebe0a9ca0d0b208453a3d7106b063f2</td>\n",
       "      <td>0x0980d5970901349d531c9fd032dfa3132b5bec48</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ethereum</td>\n",
       "      <td>0x44047731eb4993621a7fd0c3b55b46ebb7660fcf2900...</td>\n",
       "      <td>13935026</td>\n",
       "      <td>2022-01-03T21:51:13.000Z</td>\n",
       "      <td>7009</td>\n",
       "      <td>superrare</td>\n",
       "      <td>0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0</td>\n",
       "      <td>SUPR</td>\n",
       "      <td>0x8c9f364bf7a56ed058fc63ef81c6cf09c833e656</td>\n",
       "      <td>9.397873e+05</td>\n",
       "      <td>...</td>\n",
       "      <td>249970700000000000000</td>\n",
       "      <td>249.9707</td>\n",
       "      <td>118613.936623</td>\n",
       "      <td>31549700000000000000</td>\n",
       "      <td>31.5497</td>\n",
       "      <td>[0x39cc9c86e67baf2129b80fe3414c397492ea8026, 0...</td>\n",
       "      <td>secondary</td>\n",
       "      <td>0xc46db2d89327d4c41eb81c43ed5e3dff111f9a8f</td>\n",
       "      <td>0x762da606029d3120735aa1eec15464e265db7a3c</td>\n",
       "      <td>{'artist': ['XCOPY'], 'name': 'Blood Run', 'de...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                             \\\n",
       "  blockchain                                    transactionHash blockNumber   \n",
       "0   ethereum  0x21dcce949d7137778294d3b40797b3f0c81928bd8661...    13928090   \n",
       "1   ethereum  0x851d5ec47f2d766278193961c3fd582011af1fda286f...    13896377   \n",
       "2   ethereum  0xaa40b85f4a1a16fe3f6f424ada1a99053335420b167b...    13912264   \n",
       "3   ethereum  0xbfe47e67ab24622b809b80fa357a2e72a8e345543b6b...    13901896   \n",
       "4   ethereum  0x44047731eb4993621a7fd0c3b55b46ebb7660fcf2900...    13935026   \n",
       "\n",
       "                                                   \\\n",
       "             blockTimestamp assetId       project   \n",
       "0  2022-01-02T20:05:08.000Z      11     superrare   \n",
       "1  2021-12-28T22:17:44.000Z    3562  boredapeclub   \n",
       "2  2021-12-31T09:11:16.000Z    5902   cryptopunks   \n",
       "3  2021-12-29T18:32:33.000Z    6275   cryptopunks   \n",
       "4  2022-01-03T21:51:13.000Z    7009     superrare   \n",
       "\n",
       "                                                         \\\n",
       "                                   nftAddress nftTicker   \n",
       "0  0x41a322b28d0ff354040e2cbc676f0320d8c8850d      SUPR   \n",
       "1  0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d      BAYC   \n",
       "2  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb         Ͼ   \n",
       "3  0xb7f7f6c52f2e2fdb1963eab30438024864c313f6    WPUNKS   \n",
       "4  0xb932a70a57673d89f4acffbe830e8ed7f75fb9e0      SUPR   \n",
       "\n",
       "                                                             ...  \\\n",
       "                                marketAddress      usdPrice  ...   \n",
       "0  0x41a322b28d0ff354040e2cbc676f0320d8c8850d  6.196021e+06  ...   \n",
       "1  0x24550d7fbe64bfdbce7704251d3fe40b8a136c91  1.636232e+06  ...   \n",
       "2  0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb  1.204673e+06  ...   \n",
       "3  0x4748495153fb86637e4fdd8e50e3c1f611f15930  1.133475e+06  ...   \n",
       "4  0x8c9f364bf7a56ed058fc63ef81c6cf09c833e656  9.397873e+05  ...   \n",
       "\n",
       "                                                            \\\n",
       "               totalPrice totalDecimalPrice    feeUSDPrice   \n",
       "0  1630000000000000000000         1630.0000  805482.756000   \n",
       "1   430000000000000000000          430.0000   81811.585000   \n",
       "2   315000000000000000000          315.0000            NaN   \n",
       "3   300000000000000000000          300.0000            NaN   \n",
       "4   249970700000000000000          249.9707  118613.936623   \n",
       "\n",
       "                                               \\\n",
       "           feeTotalPrice feeTotalDecimalPrice   \n",
       "0  211900000000000000000             211.9000   \n",
       "1   21500000000000000000              21.5000   \n",
       "2                   None                  NaN   \n",
       "3                   None                  NaN   \n",
       "4   31549700000000000000              31.5497   \n",
       "\n",
       "                                                                 \\\n",
       "                                       feeCollectors   saleType   \n",
       "0  [0x39cc9c86e67baf2129b80fe3414c397492ea8026, 0...  secondary   \n",
       "1       [0x5b3256965e7c3cf26e11fcaf296dfc8807c01073]  secondary   \n",
       "2                                               None  secondary   \n",
       "3                                               None    primary   \n",
       "4  [0x39cc9c86e67baf2129b80fe3414c397492ea8026, 0...  secondary   \n",
       "\n",
       "                                               \\\n",
       "                                        buyer   \n",
       "0  0x63fed38f5d6f6fd6a899451c72322c44b9c5acb0   \n",
       "1  0x020ca66c30bec2c4fe3861a94e4db4a498a35872   \n",
       "2  0x801b68cc9f4fb094a28b30ca25664051e50ad3a9   \n",
       "3  0xd66fe503aebe0a9ca0d0b208453a3d7106b063f2   \n",
       "4  0xc46db2d89327d4c41eb81c43ed5e3dff111f9a8f   \n",
       "\n",
       "                                               \\\n",
       "                                       seller   \n",
       "0  0xb67994792c214039c8328bb3e0835b6a8ea7e373   \n",
       "1  0xfbe5c1ab13e206688775f117a9a90153d7fdcfd2   \n",
       "2  0x1e3685ee600983bac782b182f245efd3bbb26455   \n",
       "3  0x0980d5970901349d531c9fd032dfa3132b5bec48   \n",
       "4  0x762da606029d3120735aa1eec15464e265db7a3c   \n",
       "\n",
       "                                                      \n",
       "                                                meta  \n",
       "0  {'artist': ['N/A'], 'name': 'All Time High in ...  \n",
       "1  {'name': 'Bored Ape #3562', 'eyes': 'Zombie', ...  \n",
       "2  {'tags': ['Hoodie', 'Small Shades', 'Shadow Be...  \n",
       "3                                                NaN  \n",
       "4  {'artist': ['XCOPY'], 'name': 'Blood Run', 'de...  \n",
       "\n",
       "[5 rows x 22 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection_history_df = nf.get_collection_history(collections_in='')\n",
    "collection_history_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "54811e08",
   "metadata": {},
   "source": [
    "### get_collection_stats"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fd78d2e9",
   "metadata": {},
   "source": [
    "get stats abt collection"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "be350cfe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cryptopunks</th>\n",
       "      <th>doodles</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count-sale-latest</th>\n",
       "      <td>99</td>\n",
       "      <td>1274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>count-sale-daily</th>\n",
       "      <td>[[1641340800, 99], [1641254400, 101], [1641168...</td>\n",
       "      <td>[[1641340800, 1290], [1641254400, 1219], [1641...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>count-salesprimary-latest</th>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>count-salesprimary-daily</th>\n",
       "      <td>[[1641340800, 8], [1641254400, 9], [1641168000...</td>\n",
       "      <td>[[1641340800, 0], [1641254400, 0], [1641168000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>count-salessecondary-latest</th>\n",
       "      <td>91</td>\n",
       "      <td>1274</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>count-salessecondary-daily</th>\n",
       "      <td>[[1641340800, 91], [1641254400, 92], [16411680...</td>\n",
       "      <td>[[1641340800, 1290], [1641254400, 1219], [1641...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sum-usd-latest</th>\n",
       "      <td>30753514.921924</td>\n",
       "      <td>41137137.998815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sum-usd-daily</th>\n",
       "      <td>[[1641340800, 30753514.9219242], [1641254400, ...</td>\n",
       "      <td>[[1641340800, 42081062.39701], [1641254400, 38...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>avg-usd-latest</th>\n",
       "      <td>310641.564868</td>\n",
       "      <td>32289.747252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>avg-usd-daily</th>\n",
       "      <td>[[1641340800, 310641.56486792123], [1641254400...</td>\n",
       "      <td>[[1641340800, 32620.978602333333], [1641254400...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sum-usdprimary-latest</th>\n",
       "      <td>2709420.2789</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sum-usdprimary-daily</th>\n",
       "      <td>[[1641340800, 2709420.2789], [1641254400, 2709...</td>\n",
       "      <td>[[1641340800, 0], [1641254400, 0], [1641168000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sum-usdsecondary-latest</th>\n",
       "      <td>28044094.643024</td>\n",
       "      <td>41137137.998815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sum-usdsecondary-daily</th>\n",
       "      <td>[[1641340800, 28044094.6430242], [1641254400, ...</td>\n",
       "      <td>[[1641340800, 42081062.39701], [1641254400, 38...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sum-feeusd-latest</th>\n",
       "      <td>242808.561914</td>\n",
       "      <td>3092240.852342</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sum-feeusd-daily</th>\n",
       "      <td>[[1641340800, 242808.56191426094], [1641254400...</td>\n",
       "      <td>[[1641340800, 3178364.757174794], [1641254400,...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique-wallets-latest</th>\n",
       "      <td>125</td>\n",
       "      <td>1607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique-wallets-daily</th>\n",
       "      <td>[[1641340800, 125], [1641254400, 127], [164116...</td>\n",
       "      <td>[[1641340800, 1623], [1641254400, 1550], [1641...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique-buyer-latest</th>\n",
       "      <td>65</td>\n",
       "      <td>890</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique-buyer-daily</th>\n",
       "      <td>[[1641340800, 65], [1641254400, 67], [16411680...</td>\n",
       "      <td>[[1641340800, 902], [1641254400, 859], [164116...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique-seller-latest</th>\n",
       "      <td>71</td>\n",
       "      <td>944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unique-seller-daily</th>\n",
       "      <td>[[1641340800, 71], [1641254400, 72], [16411680...</td>\n",
       "      <td>[[1641340800, 951], [1641254400, 911], [164116...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                   cryptopunks  \\\n",
       "count-sale-latest                                                           99   \n",
       "count-sale-daily             [[1641340800, 99], [1641254400, 101], [1641168...   \n",
       "count-salesprimary-latest                                                    8   \n",
       "count-salesprimary-daily     [[1641340800, 8], [1641254400, 9], [1641168000...   \n",
       "count-salessecondary-latest                                                 91   \n",
       "count-salessecondary-daily   [[1641340800, 91], [1641254400, 92], [16411680...   \n",
       "sum-usd-latest                                                 30753514.921924   \n",
       "sum-usd-daily                [[1641340800, 30753514.9219242], [1641254400, ...   \n",
       "avg-usd-latest                                                   310641.564868   \n",
       "avg-usd-daily                [[1641340800, 310641.56486792123], [1641254400...   \n",
       "sum-usdprimary-latest                                             2709420.2789   \n",
       "sum-usdprimary-daily         [[1641340800, 2709420.2789], [1641254400, 2709...   \n",
       "sum-usdsecondary-latest                                        28044094.643024   \n",
       "sum-usdsecondary-daily       [[1641340800, 28044094.6430242], [1641254400, ...   \n",
       "sum-feeusd-latest                                                242808.561914   \n",
       "sum-feeusd-daily             [[1641340800, 242808.56191426094], [1641254400...   \n",
       "unique-wallets-latest                                                      125   \n",
       "unique-wallets-daily         [[1641340800, 125], [1641254400, 127], [164116...   \n",
       "unique-buyer-latest                                                         65   \n",
       "unique-buyer-daily           [[1641340800, 65], [1641254400, 67], [16411680...   \n",
       "unique-seller-latest                                                        71   \n",
       "unique-seller-daily          [[1641340800, 71], [1641254400, 72], [16411680...   \n",
       "\n",
       "                                                                       doodles  \n",
       "count-sale-latest                                                         1274  \n",
       "count-sale-daily             [[1641340800, 1290], [1641254400, 1219], [1641...  \n",
       "count-salesprimary-latest                                                    0  \n",
       "count-salesprimary-daily     [[1641340800, 0], [1641254400, 0], [1641168000...  \n",
       "count-salessecondary-latest                                               1274  \n",
       "count-salessecondary-daily   [[1641340800, 1290], [1641254400, 1219], [1641...  \n",
       "sum-usd-latest                                                 41137137.998815  \n",
       "sum-usd-daily                [[1641340800, 42081062.39701], [1641254400, 38...  \n",
       "avg-usd-latest                                                    32289.747252  \n",
       "avg-usd-daily                [[1641340800, 32620.978602333333], [1641254400...  \n",
       "sum-usdprimary-latest                                                        0  \n",
       "sum-usdprimary-daily         [[1641340800, 0], [1641254400, 0], [1641168000...  \n",
       "sum-usdsecondary-latest                                        41137137.998815  \n",
       "sum-usdsecondary-daily       [[1641340800, 42081062.39701], [1641254400, 38...  \n",
       "sum-feeusd-latest                                               3092240.852342  \n",
       "sum-feeusd-daily             [[1641340800, 3178364.757174794], [1641254400,...  \n",
       "unique-wallets-latest                                                     1607  \n",
       "unique-wallets-daily         [[1641340800, 1623], [1641254400, 1550], [1641...  \n",
       "unique-buyer-latest                                                        890  \n",
       "unique-buyer-daily           [[1641340800, 902], [1641254400, 859], [164116...  \n",
       "unique-seller-latest                                                       944  \n",
       "unique-seller-daily          [[1641340800, 951], [1641254400, 911], [164116...  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection_stats_df = nf.get_collection_stats(collections_in=collections)\n",
    "collection_stats_df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "781aabfa",
   "metadata": {},
   "source": [
    "### get_collection_summary"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "16127a62",
   "metadata": {},
   "source": [
    "Retrieve quick collection summary"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "232408ba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>cryptopunks</th>\n",
       "      <th>doodles</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>name</th>\n",
       "      <td>cryptopunks</td>\n",
       "      <td>doodles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tickers</th>\n",
       "      <td>[{'project': 'cryptopunks'}]</td>\n",
       "      <td>[{'project': 'doodles'}]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>categories</th>\n",
       "      <td>[Collectible]</td>\n",
       "      <td>[Collectible]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>website</th>\n",
       "      <td>https://www.larvalabs.com/cryptopunks</td>\n",
       "      <td>https://doodles.app/</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>19953</td>\n",
       "      <td>26059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>traders</th>\n",
       "      <td>5667</td>\n",
       "      <td>10823</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usd</th>\n",
       "      <td>1884762762.14</td>\n",
       "      <td>187226510.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>average</th>\n",
       "      <td>94460.12</td>\n",
       "      <td>7184.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currencies</th>\n",
       "      <td>[{'ticker': 'ETH', 'totalDecimalPrice': 651088...</td>\n",
       "      <td>[{'ticker': 'ETH', 'totalDecimalPrice': 46751....</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>daily</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                  cryptopunks  \\\n",
       "name                                              cryptopunks   \n",
       "tickers                          [{'project': 'cryptopunks'}]   \n",
       "categories                                      [Collectible]   \n",
       "website                 https://www.larvalabs.com/cryptopunks   \n",
       "count                                                   19953   \n",
       "traders                                                  5667   \n",
       "usd                                             1884762762.14   \n",
       "average                                              94460.12   \n",
       "currencies  [{'ticker': 'ETH', 'totalDecimalPrice': 651088...   \n",
       "daily                                                    None   \n",
       "\n",
       "                                                      doodles  \n",
       "name                                                  doodles  \n",
       "tickers                              [{'project': 'doodles'}]  \n",
       "categories                                      [Collectible]  \n",
       "website                                  https://doodles.app/  \n",
       "count                                                   26059  \n",
       "traders                                                 10823  \n",
       "usd                                              187226510.81  \n",
       "average                                               7184.72  \n",
       "currencies  [{'ticker': 'ETH', 'totalDecimalPrice': 46751....  \n",
       "daily                                                    None  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "collection_summary_df = nf.get_collection_summary(collections_in=collections)\n",
    "collection_summary_df"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}